package com.yun.zf.app.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.app.domain.ZfHouseDetail;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 房源表 Mapper 接口
 * </p>
 *
 * @author cj
 * @since 2021-01-29
 */
@Mapper
public interface ZfHouseDetailMapper extends BaseMapper<ZfHouseDetail> {

    @Select("<script>" +
            " SELECT  zhd.basic_id, zhd.exhaust_price ,zhd.area, zhd.bedrooms ,zhd.living_room ,zhd.toilet,zhd.floor ,zhd.total_floor ,zhd.floor_tag ,zhd.direction,zhd.is_elevator  from zf_house_detail zhd WHERE zhd.city_code=#{cityCode} and zhd.province_code=#{provCode} and zhd.basic_id=#{houseId} " +
            "</script>")
    public  ZfHouseDetail getDetail(Long houseId, Long provCode, Long cityCode);


}
